This script takes the raw outputs from the water quality sensors at Carvins Cove combines them into one file, identifies gaps in the data, runs the data through the QAQC function (qaqc_ccrwq), and produces QAQC plots for visual inspection.
This identifies if there are any daily data gaps in the long-term record
This identifies if there are any sub-daily gaps in the long-term record. Most of these gaps happen when we change the program on the data logger.
## [1] "2021-07-02 14:00:00 UTC" "2021-07-02 14:50:00 UTC"
## [1] "2022-04-05 12:00:00 UTC" "2022-04-05 14:00:00 UTC"
## [1] "2022-04-20 13:00:00 UTC" "2022-04-20 13:40:00 UTC"
## [1] "2022-04-20 14:00:00 UTC" "2022-04-20 15:00:00 UTC"
## [1] "2022-05-12 10:00:00 UTC" "2022-05-12 10:30:00 UTC"
## [1] "2022-09-29 14:00:00 UTC" "2022-09-29 15:00:00 UTC"
## [1] "2022-10-17 17:30:00 UTC" "2022-10-17 18:10:00 UTC"
## [1] "2023-01-24 16:00:00 UTC" "2023-01-24 16:50:00 UTC"
## [1] "2023-02-28 12:10:00 UTC" "2023-02-28 12:20:00 UTC"
This section reads in the QAQC file and then you can look at the head, tail and structure. Make sure the last row is Dec. 31 23:50 of the publishing year. There should be 97 columns unless a new column has been added.
## Rows: 90882 Columns: 97
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): Reservoir
## dbl (95): Site, ThermistorTemp_C_1, ThermistorTemp_C_2, ThermistorTemp_C_3,...
## dttm (1): DateTime
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## # A tibble: 6 × 97
## Reservoir Site DateTime Thermist…¹ Therm…² Therm…³ Therm…⁴ Therm…⁵
## <chr> <dbl> <dttm> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 CCR 51 2021-04-09 15:20:00 NA NA NA NA NA
## 2 CCR 51 2021-04-09 15:30:00 NA NA NA NA NA
## 3 CCR 51 2021-04-09 15:40:00 NA NA NA NA NA
## 4 CCR 51 2021-04-09 15:50:00 NA NA NA NA NA
## 5 CCR 51 2021-04-09 16:00:00 NA NA NA NA NA
## 6 CCR 51 2021-04-09 16:10:00 NA NA NA NA NA
## # … with 89 more variables: ThermistorTemp_C_6 <dbl>, ThermistorTemp_C_7 <dbl>,
## # ThermistorTemp_C_8 <dbl>, ThermistorTemp_C_9 <dbl>,
## # ThermistorTemp_C_10 <dbl>, ThermistorTemp_C_11 <dbl>,
## # ThermistorTemp_C_12 <dbl>, ThermistorTemp_C_13 <dbl>, EXOTemp_C_1 <dbl>,
## # EXOCond_uScm_1 <dbl>, EXOSpCond_uScm_1 <dbl>, EXOTDS_mgL_1 <dbl>,
## # EXODOsat_percent_1 <dbl>, EXODO_mgL_1 <dbl>, EXOChla_RFU_1 <dbl>,
## # EXOChla_ugL_1 <dbl>, EXOBGAPC_RFU_1 <dbl>, EXOBGAPC_ugL_1 <dbl>, …
## # A tibble: 6 × 97
## Reservoir Site DateTime Thermist…¹ Therm…² Therm…³ Therm…⁴ Therm…⁵
## <chr> <dbl> <dttm> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 CCR 51 2022-12-31 23:00:00 5.72 5.44 5.35 5.34 5.30
## 2 CCR 51 2022-12-31 23:10:00 5.71 5.47 5.42 5.35 5.32
## 3 CCR 51 2022-12-31 23:20:00 5.71 5.56 5.42 5.36 5.33
## 4 CCR 51 2022-12-31 23:30:00 5.71 5.59 5.40 5.35 5.32
## 5 CCR 51 2022-12-31 23:40:00 5.71 5.60 5.43 5.35 5.32
## 6 CCR 51 2022-12-31 23:50:00 5.69 5.66 5.38 5.35 5.31
## # … with 89 more variables: ThermistorTemp_C_6 <dbl>, ThermistorTemp_C_7 <dbl>,
## # ThermistorTemp_C_8 <dbl>, ThermistorTemp_C_9 <dbl>,
## # ThermistorTemp_C_10 <dbl>, ThermistorTemp_C_11 <dbl>,
## # ThermistorTemp_C_12 <dbl>, ThermistorTemp_C_13 <dbl>, EXOTemp_C_1 <dbl>,
## # EXOCond_uScm_1 <dbl>, EXOSpCond_uScm_1 <dbl>, EXOTDS_mgL_1 <dbl>,
## # EXODOsat_percent_1 <dbl>, EXODO_mgL_1 <dbl>, EXOChla_RFU_1 <dbl>,
## # EXOChla_ugL_1 <dbl>, EXOBGAPC_RFU_1 <dbl>, EXOBGAPC_ugL_1 <dbl>, …
## spc_tbl_ [90,882 × 97] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
## $ Reservoir : chr [1:90882] "CCR" "CCR" "CCR" "CCR" ...
## $ Site : num [1:90882] 51 51 51 51 51 51 51 51 51 51 ...
## $ DateTime : POSIXct[1:90882], format: "2021-04-09 15:20:00" "2021-04-09 15:30:00" ...
## $ ThermistorTemp_C_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_2 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_3 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_4 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_5 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_6 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_7 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_8 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_9 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_10 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_11 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_12 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ ThermistorTemp_C_13 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOTemp_C_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOCond_uScm_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOSpCond_uScm_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOTDS_mgL_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXODOsat_percent_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXODO_mgL_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOChla_RFU_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOChla_ugL_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOBGAPC_RFU_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOBGAPC_ugL_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOfDOM_RFU_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOfDOM_QSU_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOPressure_psi_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXODepth_m_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOBattery_V_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOCablepower_V_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOWiper_V_1 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ EXOTemp_C_9 : num [1:90882] 8.54 8.39 8.47 8.42 8.4 ...
## $ EXOCond_uScm_9 : num [1:90882] 35.2 35.2 35.2 35.2 35.2 ...
## $ EXOSpCond_uScm_9 : num [1:90882] 51.4 51.5 51.5 51.5 51.5 ...
## $ EXOTDS_mgL_9 : num [1:90882] 33.4 33.5 33.5 33.5 33.5 ...
## $ EXODOsat_percent_9 : num [1:90882] 87.8 87.2 87.3 86.8 87.3 ...
## $ EXODO_mgL_9 : num [1:90882] 10.3 10.2 10.2 10.2 10.2 ...
## $ EXOfDOM_RFU_9 : num [1:90882] 5.42 5.42 5.41 5.41 5.42 5.42 5.42 5.41 5.42 5.42 ...
## $ EXOfDOM_QSU_9 : num [1:90882] 16.5 16.5 16.4 16.4 16.5 ...
## $ EXOPressure_psi_9 : num [1:90882] 12.8 12.8 12.8 12.8 12.8 ...
## $ EXODepth_m_9 : num [1:90882] 9 9 8.99 9 9 ...
## $ EXOBattery_V_9 : num [1:90882] 3.12 3.12 3.12 3.12 3.12 3.12 3.12 3.12 3.12 3.12 ...
## $ EXOCablepower_V_9 : num [1:90882] 12.1 12.1 12.1 12.1 12.1 ...
## $ EXOWiper_V_9 : num [1:90882] 1.19 1.19 1.19 1.2 1.2 1.2 1.19 1.19 1.2 1.19 ...
## $ LvlPressure_psi_13 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ LvlDepth_m_13 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ LvlTemp_C_13 : num [1:90882] NA NA NA NA NA NA NA NA NA NA ...
## $ RECORD : num [1:90882] 8 9 10 11 12 13 14 15 16 17 ...
## $ CR3000Battery_V : num [1:90882] 13 13 12.9 12.9 12.9 ...
## $ CR3000Panel_Temp_C : num [1:90882] 20.9 21.1 21.2 21.4 21.4 ...
## $ Flag_ThermistorTemp_C_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_2 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_3 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_4 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_5 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_6 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_7 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_8 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_9 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_10: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_11: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_12: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_ThermistorTemp_C_13: num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOTemp_C_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOCond_uScm_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOSpCond_uScm_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOTDS_mgL_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXODOsat_percent_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXODO_mgL_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOChla_RFU_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOChla_ugL_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOBGAPC_RFU_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOBGAPC_ugL_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOfDOM_RFU_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOfDOM_QSU_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOPressure_psi_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXODepth_m_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOBattery_V_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOCablepower_V_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOWiper_V_1 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_EXOTemp_C_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOCond_uScm_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOSpCond_uScm_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOTDS_mgL_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXODOsat_percent_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXODO_mgL_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOfDOM_RFU_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOfDOM_QSU_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOPressure_psi_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXODepth_m_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOBattery_V_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOCablepower_V_9 : num [1:90882] 0 0 0 0 0 0 0 0 0 0 ...
## $ Flag_EXOWiper_V_9 : num [1:90882] 1 1 1 1 1 1 1 1 1 1 ...
## $ Flag_LvlPressure_psi_13 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## $ Flag_LvlTemp_C_13 : num [1:90882] 7 7 7 7 7 7 7 7 7 7 ...
## - attr(*, "spec")=
## .. cols(
## .. Reservoir = col_character(),
## .. Site = col_double(),
## .. DateTime = col_datetime(format = ""),
## .. ThermistorTemp_C_1 = col_double(),
## .. ThermistorTemp_C_2 = col_double(),
## .. ThermistorTemp_C_3 = col_double(),
## .. ThermistorTemp_C_4 = col_double(),
## .. ThermistorTemp_C_5 = col_double(),
## .. ThermistorTemp_C_6 = col_double(),
## .. ThermistorTemp_C_7 = col_double(),
## .. ThermistorTemp_C_8 = col_double(),
## .. ThermistorTemp_C_9 = col_double(),
## .. ThermistorTemp_C_10 = col_double(),
## .. ThermistorTemp_C_11 = col_double(),
## .. ThermistorTemp_C_12 = col_double(),
## .. ThermistorTemp_C_13 = col_double(),
## .. EXOTemp_C_1 = col_double(),
## .. EXOCond_uScm_1 = col_double(),
## .. EXOSpCond_uScm_1 = col_double(),
## .. EXOTDS_mgL_1 = col_double(),
## .. EXODOsat_percent_1 = col_double(),
## .. EXODO_mgL_1 = col_double(),
## .. EXOChla_RFU_1 = col_double(),
## .. EXOChla_ugL_1 = col_double(),
## .. EXOBGAPC_RFU_1 = col_double(),
## .. EXOBGAPC_ugL_1 = col_double(),
## .. EXOfDOM_RFU_1 = col_double(),
## .. EXOfDOM_QSU_1 = col_double(),
## .. EXOPressure_psi_1 = col_double(),
## .. EXODepth_m_1 = col_double(),
## .. EXOBattery_V_1 = col_double(),
## .. EXOCablepower_V_1 = col_double(),
## .. EXOWiper_V_1 = col_double(),
## .. EXOTemp_C_9 = col_double(),
## .. EXOCond_uScm_9 = col_double(),
## .. EXOSpCond_uScm_9 = col_double(),
## .. EXOTDS_mgL_9 = col_double(),
## .. EXODOsat_percent_9 = col_double(),
## .. EXODO_mgL_9 = col_double(),
## .. EXOfDOM_RFU_9 = col_double(),
## .. EXOfDOM_QSU_9 = col_double(),
## .. EXOPressure_psi_9 = col_double(),
## .. EXODepth_m_9 = col_double(),
## .. EXOBattery_V_9 = col_double(),
## .. EXOCablepower_V_9 = col_double(),
## .. EXOWiper_V_9 = col_double(),
## .. LvlPressure_psi_13 = col_double(),
## .. LvlDepth_m_13 = col_double(),
## .. LvlTemp_C_13 = col_double(),
## .. RECORD = col_double(),
## .. CR3000Battery_V = col_double(),
## .. CR3000Panel_Temp_C = col_double(),
## .. Flag_ThermistorTemp_C_1 = col_double(),
## .. Flag_ThermistorTemp_C_2 = col_double(),
## .. Flag_ThermistorTemp_C_3 = col_double(),
## .. Flag_ThermistorTemp_C_4 = col_double(),
## .. Flag_ThermistorTemp_C_5 = col_double(),
## .. Flag_ThermistorTemp_C_6 = col_double(),
## .. Flag_ThermistorTemp_C_7 = col_double(),
## .. Flag_ThermistorTemp_C_8 = col_double(),
## .. Flag_ThermistorTemp_C_9 = col_double(),
## .. Flag_ThermistorTemp_C_10 = col_double(),
## .. Flag_ThermistorTemp_C_11 = col_double(),
## .. Flag_ThermistorTemp_C_12 = col_double(),
## .. Flag_ThermistorTemp_C_13 = col_double(),
## .. Flag_EXOTemp_C_1 = col_double(),
## .. Flag_EXOCond_uScm_1 = col_double(),
## .. Flag_EXOSpCond_uScm_1 = col_double(),
## .. Flag_EXOTDS_mgL_1 = col_double(),
## .. Flag_EXODOsat_percent_1 = col_double(),
## .. Flag_EXODO_mgL_1 = col_double(),
## .. Flag_EXOChla_RFU_1 = col_double(),
## .. Flag_EXOChla_ugL_1 = col_double(),
## .. Flag_EXOBGAPC_RFU_1 = col_double(),
## .. Flag_EXOBGAPC_ugL_1 = col_double(),
## .. Flag_EXOfDOM_RFU_1 = col_double(),
## .. Flag_EXOfDOM_QSU_1 = col_double(),
## .. Flag_EXOPressure_psi_1 = col_double(),
## .. Flag_EXODepth_m_1 = col_double(),
## .. Flag_EXOBattery_V_1 = col_double(),
## .. Flag_EXOCablepower_V_1 = col_double(),
## .. Flag_EXOWiper_V_1 = col_double(),
## .. Flag_EXOTemp_C_9 = col_double(),
## .. Flag_EXOCond_uScm_9 = col_double(),
## .. Flag_EXOSpCond_uScm_9 = col_double(),
## .. Flag_EXOTDS_mgL_9 = col_double(),
## .. Flag_EXODOsat_percent_9 = col_double(),
## .. Flag_EXODO_mgL_9 = col_double(),
## .. Flag_EXOfDOM_RFU_9 = col_double(),
## .. Flag_EXOfDOM_QSU_9 = col_double(),
## .. Flag_EXOPressure_psi_9 = col_double(),
## .. Flag_EXODepth_m_9 = col_double(),
## .. Flag_EXOBattery_V_9 = col_double(),
## .. Flag_EXOCablepower_V_9 = col_double(),
## .. Flag_EXOWiper_V_9 = col_double(),
## .. Flag_LvlPressure_psi_13 = col_double(),
## .. Flag_LvlTemp_C_13 = col_double()
## .. )
## - attr(*, "problems")=<externalptr>
Let’s look at the flag Frequency for each variable. As a reminder here are the flag codes Flag values:
0: no flag
1: value removed due to maintenance and set to NA
2: negative or outlier value removed and set to NA, see Methods section for more detail on QAQC process
3: negative values set to 0
4: value removed due to fouling and set to NA
5: questionable value due to potential fouling
6: Values adjusted using a linear or square root function
7: missing data
8: Value corrected using a constant offset due to two thermistor malfunctions in Fall 2020
## Flag_ThermistorTemp_C_1
## 0 2 7 <NA>
## 24536 61715 4631 0
## Flag_ThermistorTemp_C_2
## 0 2 7 <NA>
## 73819 12432 4631 0
## Flag_ThermistorTemp_C_3
## 0 7 <NA>
## 86251 4631 0
## Flag_ThermistorTemp_C_4
## 0 7 <NA>
## 86251 4631 0
## Flag_ThermistorTemp_C_5
## 0 7 <NA>
## 86251 4631 0
## Flag_ThermistorTemp_C_6
## 0 7 <NA>
## 86250 4632 0
## Flag_ThermistorTemp_C_7
## 0 7 <NA>
## 86250 4632 0
## Flag_ThermistorTemp_C_8
## 0 7 <NA>
## 86247 4635 0
## Flag_ThermistorTemp_C_9
## 0 7 <NA>
## 86250 4632 0
## Flag_ThermistorTemp_C_10
## 0 7 <NA>
## 86246 4636 0
## Flag_ThermistorTemp_C_11
## 0 7 <NA>
## 86251 4631 0
## Flag_ThermistorTemp_C_12
## 0 7 <NA>
## 86250 4632 0
## Flag_ThermistorTemp_C_13
## 0 1 7 <NA>
## 83408 2843 4631 0
## Flag_EXOTemp_C_1
## 0 7 <NA>
## 70344 20538 0
## Flag_EXOCond_uScm_1
## 0 7 <NA>
## 70344 20538 0
## Flag_EXOSpCond_uScm_1
## 0 3 7 <NA>
## 70343 1 20538 0
## Flag_EXOTDS_mgL_1
## 0 7 <NA>
## 70344 20538 0
## Flag_EXODOsat_percent_1
## 0 7 <NA>
## 70117 20765 0
## Flag_EXODO_mgL_1
## 0 7 <NA>
## 70117 20765 0
## Flag_EXOChla_RFU_1
## 0 2 7 <NA>
## 70293 51 20538 0
## Flag_EXOChla_ugL_1
## 0 2 3 6 7 <NA>
## 45037 51 807 24449 20538 0
## Flag_EXOBGAPC_RFU_1
## 0 2 3 7 <NA>
## 50928 2 19414 20538 0
## Flag_EXOBGAPC_ugL_1
## 0 2 3 6 7 <NA>
## 18800 2 33701 17841 20538 0
## Flag_EXOfDOM_RFU_1
## 0 2 3 7 <NA>
## 70334 9 1 20538 0
## Flag_EXOfDOM_QSU_1
## 0 2 3 7 <NA>
## 70334 9 1 20538 0
## Flag_EXOPressure_psi_1
## 0 2 7 <NA>
## 70301 43 20538 0
## Flag_EXODepth_m_1
## 0 2 7 <NA>
## 70300 44 20538 0
## Flag_EXOBattery_V_1
## 0 7 <NA>
## 70344 20538 0
## Flag_EXOCablepower_V_1
## 0 7 <NA>
## 70344 20538 0
## Flag_EXOWiper_V_1
## 0 1 7 <NA>
## 36975 16543 37364 0
## Flag_EXOTemp_C_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXOCond_uScm_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXOSpCond_uScm_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXOTDS_mgL_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXODOsat_percent_9
## 0 2 7 <NA>
## 69587 2 21293 0
## Flag_EXODO_mgL_9
## 0 7 <NA>
## 69589 21293 0
## Flag_EXOfDOM_RFU_9
## 0 2 7 <NA>
## 69788 6 21088 0
## Flag_EXOfDOM_QSU_9
## 0 2 7 <NA>
## 69788 6 21088 0
## Flag_EXOPressure_psi_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXODepth_m_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXOBattery_V_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXOCablepower_V_9
## 0 7 <NA>
## 69794 21088 0
## Flag_EXOWiper_V_9
## 0 1 7 <NA>
## 65199 4595 21088 0
## Flag_LvlPressure_psi_13
## 0 7 <NA>
## 86251 4631 0
## Flag_LvlTemp_C_13
## 0 7 <NA>
## 86251 4631 0
This is information that is included in the methods file for EDI
The minimum water level for CCR was 17.6779275 and the maximum water depth was 19.6358085.
The median water level was 18.612661 and the mean water level was 18.690032.
Thermistor 1 There will be large gaps where the thermistor is out of
the water